/*
 Navicat Premium Data Transfer

 Source Server         : 172.18.30.90-mysql-dev
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : 172.18.30.90:3306
 Source Schema         : sea

 Target Server Type    : MySQL
 Target Server Version : 50726
 File Encoding         : 65001

 Date: 09/09/2024 11:08:02
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for coordinate
-- ----------------------------
DROP TABLE IF EXISTS `coordinate`;
CREATE TABLE `coordinate` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `x` double(15,0) DEFAULT NULL,
  `y` double(15,0) DEFAULT NULL,
  `z` double(15,0) DEFAULT NULL,
  `time` bigint(15) DEFAULT NULL COMMENT '时间戳',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of coordinate
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for coordinate_time
-- ----------------------------
DROP TABLE IF EXISTS `coordinate_time`;
CREATE TABLE `coordinate_time` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `time` bigint(20) DEFAULT NULL,
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of coordinate_time
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
